package com.ny.wlw;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;



public class UserDao {
    private  static final DbUntil dbUntil = new DbUntil();
    Connection  connection = dbUntil.getCon();
    public  UserDao() throws SQLException, ClassNotFoundException{
        }
        String  sql = "select * from users where username = ? and password = ?";
        PreparedStatement  preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setString(1,username);
        preparedStatement.setString(2,password);
        ResultSet resultSet = preparedStatement.executeQuery();
        User user =new User();
        if(resultSet.next()){
            int id = resultSet.getInt("id");
            String name = resultSet.getString("username");
            String password = resultSet.getString("password");
            user = new User(id,name,password);
            user.setId(id);
            user.setUserName(name);
            user.setPassword(pwd);

        }
        return user;
    }


